﻿exec dbo.aspnet_Roles_CreateRole @ApplicationName=N'/',@RoleName=N'Administrator'
go
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'ErrorLog')
	BEGIN
		DROP  Table ErrorLog
	END
GO
CREATE TABLE [dbo].[ErrorLog] (
    [Id] [int] IDENTITY (1, 1) NOT NULL,
    [Date] [datetime] NOT NULL,
    [Thread] [nvarchar] (255) NOT NULL,
    [Level] [nvarchar] (50) NOT NULL,
    [Logger] [nvarchar] (255) NOT NULL,
    [Message] [nvarchar] (4000) NOT NULL,
    [Exception] [nvarchar] (2000) NULL
    
    constraint pk_Log primary key (Id)
)
GO
 